DELETE FROM
    ModelPublication
DELETE FROM
    Publication
DELETE FROM
    PublicationType

DECLARE @PublicationTypeId1 UNIQUEIDENTIFIER
SET @PublicationTypeId1 = NEWID()

INSERT
    PublicationType
    (
     PublicationTypeId,
     Code 
    )
VALUES
    (
     @PublicationTypeId1,
     0
    )

DECLARE @PublicationId1 UNIQUEIDENTIFIER
SET @PublicationId1 = NEWID()
    
INSERT
    Publication
    (
     PublicationId,
     Code,
     PublicationTypeId,
     FollowingPublicationId        
    )
VALUES
    (
     @PublicationId1, -- PublicationId - uniqueidentifier
     'PublicationCode1', -- Code - nvarchar(25)
     @PublicationTypeId1, -- PublicationTypeId - uniqueidentifier
     NULL  -- FollowingPublicationId - uniqueidentifier        
    )
    
INSERT
    ModelPublication
    (
     ModelPublicationId,
     ModelCode,
     ModelSequence,
     PublicationId        
    )
VALUES
    (NEWID(), -- ModelPublicationId - uniqueidentifier
     'ModelCode1', -- ModelCode - nvarchar(20)
     'ModelSequence1', -- ModelSequence - nvarchar(2)
     @PublicationId1  -- PublicationId - uniqueidentifier
     )    
     
INSERT
    ModelPublication
    (
     ModelPublicationId,
     ModelCode,
     ModelSequence,
     PublicationId        
    )
VALUES
    (NEWID(), -- ModelPublicationId - uniqueidentifier
     'ModelCode1', -- ModelCode - nvarchar(20)
     'ModelSequence2', -- ModelSequence - nvarchar(2)
     @PublicationId1  -- PublicationId - uniqueidentifier
     )     